Downloadable asset reports

This articles gives a brief overview of two Asset reports as well as instructions to download and install the reports onto your system.

Overview of the Report

The Asset Tree Hierarchy Report is an often sought after tool that lets you view the Asset Tree within the Reporter rather than the Main Application (MRO). While the Main Application (MRO) interface allows for easy navigation of the Asset Tree and its levels, some users prefer to view the expanded Asset Hierarchy within a report. This can help validate the tree design, confirm the appropriate levels exist, and facilitate audits. The Base Reports within Maintenance Connection do not currently include a working report of this nature, so we have created a report to satisfy this need.

For this report to function properly, the report criteria and Sort/Group values must not be changed from the values that are set when the report is imported into your database. Changing these values can show unwanted results in displayed data.

Instructions to Download and Install

On-Premise: Based upon your company hosting its own database, your IT personnel or someone with server access will need to follow the below instructions:

1. Open the SQL file: Asset_Tree_Hierarchy.sql
2. Copy contents into a new Query window in your SQL Server Management Studio (SSMS).
3. Execute SQL script against your MC entity database prefixed with ENT.

Cloud Hosted: Based upon your database being hosted in our Data Center, you will need to make a request through our Support team to install the report.

Mean Time Between Failure (or, MTBF) is an important statistic in asset management, as it shows organizations how long a piece of equipment typically runs before a failure (i.e., a breakdown requiring repairs on the Asset before it can return to service). This segment provides two SQL scripts that you can install on your system: the first is a function that calculates MTBF, and the second is a report that display the MTBF for Assets.

Overview of the MTBF Function and Report

The basic formula for determining MTBF is to divide the total operating time (or, "uptime") of an Asset by the total number of failures/breakdowns of the Asset, thus showing the average (or mean) time the Asset runs before a failure. While the function provided here in some ways mirrors the standard MTBF formula, it may be important to note that it does not account for uptime or downtime in its calculation. Instead, this function divides the total time between the first and last Corrective WO's performed on the Asset by the total number of Corrective WO's performed on the Asset. Typically, this calculation for MTBF will approach the standard calculation, especially as the total number of failures (i.e., Corrective WO's) grows. However, not accounting for downtime results in significantly divergent results between the calculations early on in the life of the Asset.

If you determine that the MTBF function provided will suit the needs of your organization, use the instructions below to install the function onto your system. Once the function is installed, you can install the report provided here that will show MTBF results for your Assets. You can also change report criteria as needed to view the MTBF for particular Assets or sets of Assets.

If you need further guidance in determining whether to run these scripts in your system, please reach out to our Customer Success team for a consultation.

Instructions to Download and Install

On-Premise:

1. Open the SQL file for the MTBF function: MTBF_Function.sql
2. Copy contents into a new Query window in your SQL Server Management Studio (SSMS).
3. Execute SQL script against your MC entity database prefixed with ENT.
4. Repeat these steps with the SQL file for the MTBF report: MTBF_Report.sql

Cloud Hosted: Based upon your database being hosted in our Data Center, you will need to make a request through our Support team to install the report.